Stored Procedures [dbo].[BAEImisUDFieldLoad]
SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEImisUDFieldLoad
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@TableNamevarchar(30)30
@FieldNamevarchar(30)30
SQL Script
create procedure [dbo].[BAEImisUDFieldLoad] @TableName as
varchar(30),
        @FieldName    AS    varchar(30)
    AS
SELECT *
    FROM UD_Field udf
LEFT JOIN UD_WindowFields odw ON udf.TABLE_NAME = odw.TABLE_NAME AND udf.FIELD_NAME = odw.FIELD_NAME
WHERE
    udf.TABLE_NAME = @TableName AND udf.FIELD_NAME = @FieldName

GO
Uses
Created 05 April 2012 11:11
Copyright  2012 - All Rights Reserved